using System;

namespace Agile.DataAccess
{
    /// <summary>
    /// 
    /// </summary>
    public interface IStoredProcedureBuilderDynamic : IExecute, IQuery, IParameterValue, IDisposable
	{
        /// <summary>
        /// 
        /// </summary>
		BuilderData Data { get; }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ignoreProperties"></param>
        /// <returns></returns>
		IStoredProcedureBuilderDynamic AutoMap(params string[] ignoreProperties);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="name"></param>
        /// <param name="value"></param>
        /// <param name="parameterType"></param>
        /// <param name="size"></param>
        /// <returns></returns>
		IStoredProcedureBuilderDynamic Parameter(string name, object value, DataTypes parameterType = DataTypes.Object, int size = 0);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="name"></param>
        /// <param name="parameterType"></param>
        /// <param name="size"></param>
        /// <returns></returns>
		IStoredProcedureBuilderDynamic ParameterOut(string name, DataTypes parameterType, int size = 0);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="useMultipleResultsets"></param>
        /// <returns></returns>
		IStoredProcedureBuilderDynamic UseMultiResult(bool useMultipleResultsets);	
	}
}